Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	5787
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	542.7 KiB
Average record size in memory	96.0 B

Variable types

Numeric	12

Warnings

`avg_recency_days` is highly correlated with `frequency`	High correlation
`avg_basket_size` is highly correlated with `returned_revenue` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `orders` and 1 other fields	High correlation
`returned_revenue` is highly correlated with `avg_basket_size` and 1 other fields	High correlation
`orders` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qt_products` is highly correlated with `orders`	High correlation
`qt_items` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`average_ticket` is highly correlated with `avg_basket_size` and 1 other fields	High correlation
`avg_recency_days` is highly correlated with `orders` and 2 other fields	High correlation
`avg_basket_size` is highly correlated with `avg_unique_basket_size` and 4 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `avg_basket_size` and 2 other fields	High correlation
`gross_revenue` is highly correlated with `avg_basket_size` and 4 other fields	High correlation
`last_purchase` is highly correlated with `orders` and 1 other fields	High correlation
`orders` is highly correlated with `avg_recency_days` and 5 other fields	High correlation
`qt_products` is highly correlated with `avg_basket_size` and 5 other fields	High correlation
`qt_items` is highly correlated with `avg_recency_days` and 5 other fields	High correlation
`frequency` is highly correlated with `avg_recency_days` and 2 other fields	High correlation
`average_ticket` is highly correlated with `avg_basket_size` and 4 other fields	High correlation
`customer_id` is highly correlated with `avg_recency_days` and 2 other fields	High correlation
`avg_recency_days` is highly correlated with `customer_id` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `returned_revenue` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `avg_basket_size` and 3 other fields	High correlation
`returned_revenue` is highly correlated with `customer_id` and 1 other fields	High correlation
`last_purchase` is highly correlated with `orders`	High correlation
`orders` is highly correlated with `customer_id` and 2 other fields	High correlation
`qt_products` is highly correlated with `avg_unique_basket_size` and 2 other fields	High correlation
`qt_items` is highly correlated with `avg_basket_size` and 3 other fields	High correlation
`frequency` is highly correlated with `avg_recency_days` and 2 other fields	High correlation
`average_ticket` is highly correlated with `avg_basket_size` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `qt_items` and 3 other fields	High correlation
`qt_items` is highly correlated with `avg_basket_size` and 4 other fields	High correlation
`gross_revenue` is highly correlated with `avg_basket_size` and 4 other fields	High correlation
`orders` is highly correlated with `qt_items` and 2 other fields	High correlation
`returned_revenue` is highly correlated with `avg_basket_size` and 3 other fields	High correlation
`qt_products` is highly correlated with `qt_items` and 2 other fields	High correlation
`average_ticket` is highly correlated with `avg_basket_size` and 1 other fields	High correlation
`customer_id` is highly correlated with `last_purchase`	High correlation
`last_purchase` is highly correlated with `customer_id`	High correlation
`avg_basket_size` is highly skewed (γ1 = 48.87915101)	Skewed
`gross_revenue` is highly skewed (γ1 = 21.78638916)	Skewed
`returned_revenue` is highly skewed (γ1 = 59.94180828)	Skewed
`qt_items` is highly skewed (γ1 = 23.22477286)	Skewed
`average_ticket` is highly skewed (γ1 = 28.00259794)	Skewed
`customer_id` has unique values	Unique
`avg_recency_days` has 3013 (52.1%) zeros	Zeros
`avg_basket_size` has 91 (1.6%) zeros	Zeros
`avg_unique_basket_size` has 91 (1.6%) zeros	Zeros
`gross_revenue` has 91 (1.6%) zeros	Zeros
`returned_revenue` has 4190 (72.4%) zeros	Zeros
`last_purchase` has 129 (2.2%) zeros	Zeros
`orders` has 91 (1.6%) zeros	Zeros
`qt_products` has 91 (1.6%) zeros	Zeros
`qt_items` has 91 (1.6%) zeros	Zeros
`frequency` has 91 (1.6%) zeros	Zeros
`average_ticket` has 91 (1.6%) zeros	Zeros

Reproduction

Analysis started	2021-08-10 21:17:28.929123
Analysis finished	2021-08-10 21:18:04.781082
Duration	35.85 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

customer_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	5787
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16640.72162

Minimum	12346
Maximum	22709
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	12346
5-th percentile	12702.3
Q1	14306.5
median	16270
Q3	18261.5
95-th percentile	21774.7
Maximum	22709
Range	10363
Interquartile range (IQR)	3955

Descriptive statistics

Standard deviation	2825.014253
Coefficient of variation (CV)	0.1697651291
Kurtosis	-0.8551246034
Mean	16640.72162
Median Absolute Deviation (MAD)	1978
Skewness	0.4234066713
Sum	96299856
Variance	7980705.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
15584	1	< 0.1%
21088	1	< 0.1%
21087	1	< 0.1%
21086	1	< 0.1%
15578	1	< 0.1%
12424	1	< 0.1%
21084	1	< 0.1%
17837	1	< 0.1%
21081	1	< 0.1%
Other values (5777)	5777	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12346	1	< 0.1%
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%

Value	Count	Frequency (%)
22709	1	< 0.1%
22708	1	< 0.1%
22707	1	< 0.1%
22706	1	< 0.1%
22705	1	< 0.1%
22704	1	< 0.1%
22700	1	< 0.1%
22699	1	< 0.1%
22696	1	< 0.1%
22695	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1156
Distinct (%)	20.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.77016413

Minimum	0
Maximum	366
Zeros	3013
Zeros (%)	52.1%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	56.41666667
95-th percentile	164
Maximum	366
Range	366
Interquartile range (IQR)	56.41666667

Descriptive statistics

Standard deviation	60.58422735
Coefficient of variation (CV)	1.604023407
Kurtosis	6.556761959
Mean	37.77016413
Median Absolute Deviation (MAD)	0
Skewness	2.356093233
Sum	218575.9398
Variance	3670.448604
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3013	52.1%
70	21	0.4%
46	18	0.3%
55	17	0.3%
49	16	0.3%
31	16	0.3%
91	16	0.3%
21	15	0.3%
35	15	0.3%
42	15	0.3%
Other values (1146)	2625	45.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3013	52.1%
1	9	0.2%
2	4	0.1%
2.861538462	1	< 0.1%
3	6	0.1%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	5	0.1%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	< 0.1%
356	1	< 0.1%
355	2	< 0.1%
352	1	< 0.1%
351	2	< 0.1%
350	3	0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	2370
Distinct (%)	41.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	263.9606991

Minimum	0
Maximum	74215
Zeros	91
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	72
median	148
Q3	288
95-th percentile	731.7
Maximum	74215
Range	74215
Interquartile range (IQR)	216

Descriptive statistics

Standard deviation	1190.096034
Coefficient of variation (CV)	4.508610708
Kurtosis	2809.373976
Mean	263.9606991
Median Absolute Deviation (MAD)	97
Skewness	48.87915101
Sum	1527540.566
Variance	1416328.571
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	115	2.0%
0	91	1.6%
2	72	1.2%
3	51	0.9%
4	49	0.8%
5	35	0.6%
6	29	0.5%
12	26	0.4%
72	22	0.4%
100	22	0.4%
Other values (2360)	5275	91.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	91	1.6%
1	115	2.0%
2	72	1.2%
3	51	0.9%
3.333333333	1	< 0.1%
4	49	0.8%
5	35	0.6%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6	29	0.5%

Value	Count	Frequency (%)
74215	1	< 0.1%
40498.5	1	< 0.1%
14149	1	< 0.1%
13956	1	< 0.1%
7824	1	< 0.1%
6009.333333	1	< 0.1%
5963	1	< 0.1%
5197	1	< 0.1%
4300	1	< 0.1%
4282	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1172
Distinct (%)	20.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.66374376

Minimum	0
Maximum	1109
Zeros	91
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	7
median	15
Q3	30.46428571
95-th percentile	171.7
Maximum	1109
Range	1109
Interquartile range (IQR)	23.46428571

Descriptive statistics

Standard deviation	76.4113062
Coefficient of variation (CV)	2.084110851
Kurtosis	33.35657014
Mean	36.66374376
Median Absolute Deviation (MAD)	10
Skewness	5.107288829
Sum	212173.0851
Variance	5838.687716
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	278	4.8%
2	161	2.8%
3	115	2.0%
9	105	1.8%
10	105	1.8%
8	103	1.8%
6	101	1.7%
5	101	1.7%
7	101	1.7%
13	97	1.7%
Other values (1162)	4520	78.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	91	1.6%
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	7	0.1%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.2%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%

Value	Count	Frequency (%)
1109	1	< 0.1%
748	1	< 0.1%
730	1	< 0.1%
720	1	< 0.1%
703	1	< 0.1%
686	1	< 0.1%
675	1	< 0.1%
673	1	< 0.1%
660	1	< 0.1%
649	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	5435
Distinct (%)	93.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1775.208372

Minimum	0
Maximum	279138.02
Zeros	91
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	0
5-th percentile	7.95
Q1	221.125
median	599.36
Q3	1551.68
95-th percentile	5230.976
Maximum	279138.02
Range	279138.02
Interquartile range (IQR)	1330.555

Descriptive statistics

Standard deviation	7837.600213
Coefficient of variation (CV)	4.415031123
Kurtosis	617.32801
Mean	1775.208372
Median Absolute Deviation (MAD)	480.56
Skewness	21.78638916
Sum	10273130.85
Variance	61427977.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	91	1.6%
7.95	9	0.2%
4.95	8	0.1%
2.95	8	0.1%
1.25	8	0.1%
3.75	7	0.1%
12.75	7	0.1%
1.65	7	0.1%
5.95	6	0.1%
7.5	6	0.1%
Other values (5425)	5630	97.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	91	1.6%
0.42	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.84	4	0.1%
0.85	3	0.1%
1.07	1	< 0.1%
1.25	8	0.1%
1.44	1	< 0.1%
1.65	7	0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
77183.6	1	< 0.1%
72882.09	1	< 0.1%

returned_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	1122
Distinct (%)	19.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84.00230171

Minimum	0
Maximum	168469.6
Zeros	4190
Zeros (%)	72.4%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	5.305
95-th percentile	119.473
Maximum	168469.6
Range	168469.6
Interquartile range (IQR)	5.305

Descriptive statistics

Standard deviation	2473.930809
Coefficient of variation (CV)	29.45075026
Kurtosis	3874.877918
Mean	84.00230171
Median Absolute Deviation (MAD)	0
Skewness	59.94180828
Sum	486121.32
Variance	6120333.647
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4190	72.4%
12.75	21	0.4%
4.95	20	0.3%
15	19	0.3%
9.95	17	0.3%
5.9	13	0.2%
25.5	11	0.2%
3.75	10	0.2%
4.25	10	0.2%
19.8	10	0.2%
Other values (1112)	1466	25.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4190	72.4%
0.42	2	< 0.1%
0.65	1	< 0.1%
0.95	1	< 0.1%
1.25	6	0.1%
1.45	4	0.1%
1.64	1	< 0.1%
1.65	5	0.1%
1.7	2	< 0.1%
1.79	1	< 0.1%

Value	Count	Frequency (%)
168469.6	1	< 0.1%
77183.6	1	< 0.1%
22998.4	1	< 0.1%
14688.24	1	< 0.1%
8511.15	1	< 0.1%
7443.59	1	< 0.1%
5228.4	1	< 0.1%
4815.26	1	< 0.1%
4814.74	1	< 0.1%
4486.24	1	< 0.1%

last_purchase
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	304
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	115.0687748

Minimum	0
Maximum	373
Zeros	129
Zeros (%)	2.2%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	21
median	68
Q3	198
95-th percentile	337
Maximum	373
Range	373
Interquartile range (IQR)	177

Descriptive statistics

Standard deviation	111.7168247
Coefficient of variation (CV)	0.9708700282
Kurtosis	-0.6131776373
Mean	115.0687748
Median Absolute Deviation (MAD)	60
Skewness	0.8315491535
Sum	665903
Variance	12480.64892
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	129	2.2%
1	110	1.9%
4	105	1.8%
3	98	1.7%
2	92	1.6%
10	86	1.5%
8	82	1.4%
17	79	1.4%
9	79	1.4%
7	78	1.3%
Other values (294)	4849	83.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	129	2.2%
1	110	1.9%
2	92	1.6%
3	98	1.7%
4	105	1.8%
5	52	0.9%
7	78	1.3%
8	82	1.4%
9	79	1.4%
10	86	1.5%

Value	Count	Frequency (%)
373	23	0.4%
372	23	0.4%
371	17	0.3%
369	4	0.1%
368	13	0.2%
367	16	0.3%
366	15	0.3%
365	19	0.3%
364	11	0.2%
362	7	0.1%

orders
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	57
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.416450665

Minimum	0
Maximum	206
Zeros	91
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	4
95-th percentile	11
Maximum	206
Range	206
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	6.772720769
Coefficient of variation (CV)	1.982385063
Kurtosis	304.9238656
Mean	3.416450665
Median Absolute Deviation (MAD)	1
Skewness	13.23985225
Sum	19771
Variance	45.86974661
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2871	49.6%
2	826	14.3%
3	503	8.7%
4	394	6.8%
5	237	4.1%
6	173	3.0%
7	138	2.4%
8	98	1.7%
0	91	1.6%
9	69	1.2%
Other values (47)	387	6.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	91	1.6%
1	2871	49.6%
2	826	14.3%
3	503	8.7%
4	394	6.8%
5	237	4.1%
6	173	3.0%
7	138	2.4%
8	98	1.7%
9	69	1.2%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	< 0.1%
60	1	< 0.1%
57	1	< 0.1%

qt_products
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	530
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	91.13789528

Minimum	0
Maximum	7838
Zeros	91
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	13
median	39
Q3	104
95-th percentile	330.7
Maximum	7838
Range	7838
Interquartile range (IQR)	91

Descriptive statistics

Standard deviation	209.218436
Coefficient of variation (CV)	2.295625056
Kurtosis	515.8908895
Mean	91.13789528
Median Absolute Deviation (MAD)	32
Skewness	17.83370582
Sum	527415
Variance	43772.35395
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	256	4.4%
2	149	2.6%
3	109	1.9%
10	101	1.7%
6	99	1.7%
9	92	1.6%
5	91	1.6%
0	91	1.6%
4	87	1.5%
7	83	1.4%
Other values (520)	4629	80.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	91	1.6%
1	256	4.4%
2	149	2.6%
3	109	1.9%
4	87	1.5%
5	91	1.6%
6	99	1.7%
7	83	1.4%
8	81	1.4%
9	92	1.6%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

qt_items
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	1842
Distinct (%)	31.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	963.0902022

Minimum	0
Maximum	196844
Zeros	91
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	100
median	308
Q3	797
95-th percentile	2897.5
Maximum	196844
Range	196844
Interquartile range (IQR)	697

Descriptive statistics

Standard deviation	4395.384863
Coefficient of variation (CV)	4.563835094
Kurtosis	797.1697164
Mean	963.0902022
Median Absolute Deviation (MAD)	252
Skewness	23.22477286
Sum	5573403
Variance	19319408.09
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	114	2.0%
0	91	1.6%
2	73	1.3%
3	51	0.9%
4	49	0.8%
5	35	0.6%
6	29	0.5%
12	25	0.4%
88	22	0.4%
72	21	0.4%
Other values (1832)	5277	91.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	91	1.6%
1	114	2.0%
2	73	1.3%
3	51	0.9%
4	49	0.8%
5	35	0.6%
6	29	0.5%
7	20	0.3%
8	18	0.3%
9	7	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
74215	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1227
Distinct (%)	21.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.53859758

Minimum	0
Maximum	17
Zeros	91
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0.00978156735
Q1	0.02380952381
median	1
Q3	1
95-th percentile	1
Maximum	17
Range	17
Interquartile range (IQR)	0.9761904762

Descriptive statistics

Standard deviation	0.5501400023
Coefficient of variation (CV)	1.021430513
Kurtosis	137.3129067
Mean	0.53859758
Median Absolute Deviation (MAD)	0.6
Skewness	4.81623109
Sum	3116.864195
Variance	0.3026540221
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2879	49.7%
0	91	1.6%
2	47	0.8%
0.0625	18	0.3%
0.02777777778	17	0.3%
0.02380952381	16	0.3%
0.08333333333	15	0.3%
0.09090909091	15	0.3%
0.03448275862	14	0.2%
0.02941176471	14	0.2%
Other values (1217)	2661	46.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	91	1.6%
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	< 0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	< 0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	< 0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
4	1	< 0.1%
3	5	0.1%
2	47	0.8%
1.142857143	1	< 0.1%
1	2879	49.7%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%

average_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	5448
Distinct (%)	94.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	572.8375319

Minimum	0
Maximum	84236.25
Zeros	91
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	45.3 KiB

Quantile statistics

Minimum	0
5-th percentile	7.95
Q1	154.0867045
median	291.2078571
Q3	480.6578571
95-th percentile	1830.412
Maximum	84236.25
Range	84236.25
Interquartile range (IQR)	326.5711526

Descriptive statistics

Standard deviation	2025.824087
Coefficient of variation (CV)	3.536472339
Kurtosis	1001.662008
Mean	572.8375319
Median Absolute Deviation (MAD)	152.6828571
Skewness	28.00259794
Sum	3315010.797
Variance	4103963.23
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	91	1.6%
7.95	9	0.2%
2.95	8	0.1%
4.95	8	0.1%
1.25	8	0.1%
12.75	7	0.1%
1.65	7	0.1%
3.75	7	0.1%
4.25	6	0.1%
7.5	6	0.1%
Other values (5438)	5630	97.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	91	1.6%
0.42	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.84	4	0.1%
0.85	3	0.1%
1.07	1	< 0.1%
1.25	8	0.1%
1.44	1	< 0.1%
1.65	7	0.1%

Value	Count	Frequency (%)
84236.25	1	< 0.1%
77183.6	1	< 0.1%
52940.94	1	< 0.1%
50653.91	1	< 0.1%
21389.6	1	< 0.1%
18745.86	1	< 0.1%
14855.53	1	< 0.1%
14844.76667	1	< 0.1%
13305.5	1	< 0.1%
12681.58	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	customer_id	avg_recency_days	avg_basket_size	avg_unique_basket_size	gross_revenue	returned_revenue	last_purchase	orders	qt_products	qt_items	frequency	average_ticket
0	17850	1.000000	50.970588	0.617647	5391.21	102.58	372.0	34.0	297.0	1733.0	17.000000	158.565000
1	13047	52.833333	154.444444	11.666667	3232.59	143.49	56.0	9.0	171.0	1390.0	0.028302	359.176667
2	12583	26.500000	335.200000	7.600000	6705.38	76.04	2.0	15.0	232.0	5028.0	0.040323	447.025333
3	13748	92.666667	87.800000	4.800000	948.25	0.00	95.0	5.0	28.0	439.0	0.017921	189.650000
4	15100	20.000000	26.666667	0.333333	876.00	240.90	333.0	3.0	3.0	80.0	0.073171	292.000000
5	15291	26.769231	150.142857	4.357143	4623.30	71.79	25.0	14.0	102.0	2102.0	0.040115	330.235714
6	14688	19.263158	172.428571	7.047619	5630.87	523.49	7.0	21.0	327.0	3621.0	0.057221	268.136667
7	17809	39.666667	171.416667	3.833333	5411.91	67.06	16.0	12.0	61.0	2057.0	0.033520	450.992500
8	15311	4.191011	419.714286	6.230769	60767.90	1348.56	0.0	91.0	2379.0	38194.0	0.243316	667.779121
9	16098	47.666667	87.571429	4.857143	2005.63	0.00	87.0	7.0	67.0	613.0	0.024390	286.518571

Last rows

	customer_id	avg_basket_size	avg_unique_basket_size	gross_revenue	last_purchase	orders	qt_products	qt_items	frequency	average_ticket
5777	22700	1074.0	55.0	4839.42	1.0	1.0	62.0	1074.0	1.0	4839.42
5778	13298	96.0	2.0	360.00	1.0	1.0	2.0	96.0	1.0	360.00
5779	14569	79.0	10.0	227.39	1.0	1.0	12.0	79.0	1.0	227.39
5780	22704	14.0	7.0	17.90	1.0	1.0	7.0	14.0	1.0	17.90
5781	22705	2.0	2.0	3.35	1.0	1.0	2.0	2.0	1.0	3.35
5782	22706	1747.0	634.0	5699.00	1.0	1.0	634.0	1747.0	1.0	5699.00
5783	22707	2010.0	730.0	6756.06	0.0	1.0	730.0	2010.0	1.0	6756.06
5784	22708	654.0	56.0	3217.20	0.0	1.0	59.0	654.0	1.0	3217.20
5785	22709	731.0	217.0	3950.72	0.0	1.0	217.0	731.0	1.0	3950.72
5786	12713	505.0	37.0	794.55	0.0	1.0	37.0	505.0	1.0	794.55

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows